192
How do I display radio buttons for all cells in the column


IColumn{oDCOCX_Exontrol1:Columns:Add("Radio")}:[Def,exCellHasRadioButton] := true
oDCOCX_Exontrol1:Items:AddItem(0)
oDCOCX_Exontrol1:Items:AddItem(1)
191
How do I display checkboxes for all cells in the column


IColumn{oDCOCX_Exontrol1:Columns:Add("Check")}:[Def,exCellHasCheckBox] := true
oDCOCX_Exontrol1:Items:AddItem(0)
oDCOCX_Exontrol1:Items:AddItem(1)
247
How do I display as strikeout an item

local var_Items as IItems

oDCOCX_Exontrol1:Columns:Add("Default")
var_Items := oDCOCX_Exontrol1:Items
	var_Items:[ItemStrikeOut,var_Items:AddItem("strikeout")] := true
248
How do I display as strikeout a cell or an item

local var_Items as IItems

oDCOCX_Exontrol1:Columns:Add("Default")
var_Items := oDCOCX_Exontrol1:Items
	var_Items:[CellCaptionFormat,var_Items:AddItem("gets <s>strikeout</s> only a portion of text"),0] := exHTML
249
How do I display as strikeout a cell

local var_Items as IItems

oDCOCX_Exontrol1:Columns:Add("Default")
var_Items := oDCOCX_Exontrol1:Items
	var_Items:[CellStrikeOut,var_Items:AddItem("strikeout"),0] := true
241
How do I display as italic an item

local var_Items as IItems

oDCOCX_Exontrol1:Columns:Add("Default")
var_Items := oDCOCX_Exontrol1:Items
	var_Items:[ItemItalic,var_Items:AddItem("italic")] := true
242
How do I display as italic a cell or an item

local var_Items as IItems

oDCOCX_Exontrol1:Columns:Add("Default")
var_Items := oDCOCX_Exontrol1:Items
	var_Items:[CellCaptionFormat,var_Items:AddItem("gets <i>italic</i> only a portion of text"),0] := exHTML
243
How do I display as italic a cell

local var_Items as IItems

oDCOCX_Exontrol1:Columns:Add("Default")
var_Items := oDCOCX_Exontrol1:Items
	var_Items:[CellItalic,var_Items:AddItem("italic"),0] := true
90
How do I disable the full-row selection in the control


oDCOCX_Exontrol1:FullRowSelect := false
oDCOCX_Exontrol1:Columns:Add("Column")
oDCOCX_Exontrol1:Items:AddItem("One")
oDCOCX_Exontrol1:Items:AddItem("Two")
113
How do I disable the control


oDCOCX_Exontrol1:Enabled := false
80
How do I disable sorting the columns when clicking the control's header


oDCOCX_Exontrol1:SortOnClick := exNoSort
oDCOCX_Exontrol1:Columns:Add("1")
oDCOCX_Exontrol1:Columns:Add("2")
81
How do I disable sorting a specified column when clicking its header


oDCOCX_Exontrol1:Columns:Add("1")
IColumn{oDCOCX_Exontrol1:Columns:Add("NoSort")}:AllowSort := false
118
How do I disable showing the tooltip for all control

oDCOCX_Exontrol1:ToolTipDelay := 0
IColumn{oDCOCX_Exontrol1:Columns:Add("tootip")}:ToolTip := "this is a tooltip assigned to a column"
178
How do I disable resizing a column at runtime


IColumn{oDCOCX_Exontrol1:Columns:Add("Unsizable")}:AllowSizing := false
oDCOCX_Exontrol1:Columns:Add("C2")
oDCOCX_Exontrol1:Columns:Add("C3")
oDCOCX_Exontrol1:Columns:Add("C4")
250
How do I disable or enable an item

local var_Items as IItems

oDCOCX_Exontrol1:Columns:Add("Default")
var_Items := oDCOCX_Exontrol1:Items
	var_Items:[EnableItem,var_Items:AddItem("disabled")] := false
oDCOCX_Exontrol1:Items:AddItem("enabled")
179
How do I disable drag and drop columns


IColumn{oDCOCX_Exontrol1:Columns:Add("C1")}:AllowDragging := false
IColumn{oDCOCX_Exontrol1:Columns:Add("C2")}:AllowDragging := false
51
How do I change visual appearance of the +/- ( expand/collapse ) buttons

local var_Items as IItems
local h as USUAL

oDCOCX_Exontrol1:LinesAtRoot := exGroupLinesAtRoot
oDCOCX_Exontrol1:HasButtons := exWPlus
oDCOCX_Exontrol1:Columns:Add("Column")
var_Items := oDCOCX_Exontrol1:Items
	h := var_Items:AddItem("Root 1")
	var_Items:InsertItem(h,nil,"Child 1")
	var_Items:InsertItem(h,nil,"Child 2")
	var_Items:[ExpandItem,h] := true
	h := var_Items:AddItem("Root 2")
	var_Items:InsertItem(h,nil,"Child")
266
How do I change the visual effect for the cell, using your EBN files

local var_Items as IItems
local h as USUAL

oDCOCX_Exontrol1:VisualAppearance:Add(1,"c:\exontrol\images\normal.ebn")
oDCOCX_Exontrol1:Columns:Add("C1")
oDCOCX_Exontrol1:Columns:Add("C2")
var_Items := oDCOCX_Exontrol1:Items
	h := var_Items:AddItem("Cell 1")
	var_Items:[CellCaption,h,1] := "Cell 2"
	var_Items:[CellBackColor,h,1] := 0x1000000
147
How do I change the visual aspect only for the thumb in the scroll bar, using EBN


oDCOCX_Exontrol1:VisualAppearance:Add(1,"c:\exontrol\images\normal.ebn")
oDCOCX_Exontrol1:VisualAppearance:Add(2,"c:\exontrol\images\pushed.ebn")
oDCOCX_Exontrol1:VisualAppearance:Add(3,"c:\exontrol\images\hot.ebn")
oDCOCX_Exontrol1:[Background,exHSThumb] := 0x1000000
oDCOCX_Exontrol1:[Background,exHSThumbP] := 0x2000000
oDCOCX_Exontrol1:[Background,exHSThumbH] := 0x3000000
oDCOCX_Exontrol1:ColumnAutoResize := false
IColumn{oDCOCX_Exontrol1:Columns:Add("S")}:Width := 483
140
How do I change the visual aspect of the drop down filter button, using EBN


oDCOCX_Exontrol1:VisualAppearance:Add(1,"c:\exontrol\images\normal.ebn")
oDCOCX_Exontrol1:[Background,exHeaderFilterBarButton] := 0x1000000
IColumn{oDCOCX_Exontrol1:Columns:Add("Filter")}:DisplayFilterButton := true
143
How do I change the visual aspect of the drop down calendar window, that shows up if I click the drop down filter button, using EBN

local var_Column as IColumn

oDCOCX_Exontrol1:VisualAppearance:Add(1,"c:\exontrol\images\normal.ebn")
oDCOCX_Exontrol1:VisualAppearance:Add(2,"c:\exontrol\images\pushed.ebn")
oDCOCX_Exontrol1:[Background,exDateHeader] := 0x1000000
oDCOCX_Exontrol1:[Background,exDateTodayUp] := 0x1000000
oDCOCX_Exontrol1:[Background,exDateTodayDown] := 0x2000000
oDCOCX_Exontrol1:[Background,exDateScrollThumb] := 0x1000000
oDCOCX_Exontrol1:[Background,exDateScrollRange] := RGB(230,230,230)
oDCOCX_Exontrol1:[Background,exDateSeparatorBar] := RGB(230,230,230)
oDCOCX_Exontrol1:[Background,exDateSelect] := 0x1000000
var_Column := IColumn{oDCOCX_Exontrol1:Columns:Add("Date")}
	var_Column:FilterType := exDate
	var_Column:DisplayFilterButton := true
	var_Column:DisplayFilterDate := true
142
How do I change the visual aspect of the close button in the filter bar, using EBN


oDCOCX_Exontrol1:VisualAppearance:Add(1,"c:\exontrol\images\normal.ebn")
oDCOCX_Exontrol1:[Background,exFooterFilterBarButton] := 0x1000000
IColumn{oDCOCX_Exontrol1:Columns:Add("Filter")}:FilterType := exBlanks
oDCOCX_Exontrol1:ApplyFilter()
144
How do I change the visual aspect of selected item in the drop down filter window, using your EBN technology


oDCOCX_Exontrol1:VisualAppearance:Add(1,"c:\exontrol\images\normal.ebn")
oDCOCX_Exontrol1:[Background,exSelBackColorFilter] := 0x1000000
oDCOCX_Exontrol1:[Background,exSelForeColorFilter] := RGB(255,20,20)
IColumn{oDCOCX_Exontrol1:Columns:Add("Filter")}:DisplayFilterButton := true
141
How do I change the visual aspect of buttons in the cell, using EBN


oDCOCX_Exontrol1:VisualAppearance:Add(1,"c:\exontrol\images\normal.ebn")
oDCOCX_Exontrol1:VisualAppearance:Add(2,"c:\exontrol\images\pushed.ebn")
oDCOCX_Exontrol1:[Background,exCellButtonUp] := 0x1000000
oDCOCX_Exontrol1:[Background,exSizeGrip] := 0x2000000
oDCOCX_Exontrol1:SelForeColor := RGB(0,0,0)
oDCOCX_Exontrol1:ShowFocusRect := false
IColumn{oDCOCX_Exontrol1:Columns:Add("Column 1")}:[Def,exCellHasButton] := true
oDCOCX_Exontrol1:Items:AddItem("Button 1")
oDCOCX_Exontrol1:Items:AddItem("Button 2")
oDCOCX_Exontrol1:Columns:Add("Column 2")
148
How do I change the visual aspect for thumb parts in the scroll bars, using EBN

local var_Items as IItems

oDCOCX_Exontrol1:VisualAppearance:Add(1,"c:\exontrol\images\normal.ebn")
oDCOCX_Exontrol1:VisualAppearance:Add(2,"c:\exontrol\images\pushed.ebn")
oDCOCX_Exontrol1:VisualAppearance:Add(3,"c:\exontrol\images\hot.ebn")
oDCOCX_Exontrol1:[Background,exHSThumb] := 0x1000000
oDCOCX_Exontrol1:[Background,exHSThumbP] := 0x2000000
oDCOCX_Exontrol1:[Background,exHSThumbH] := 0x3000000
oDCOCX_Exontrol1:[Background,exVSThumb] := 0x1000000
oDCOCX_Exontrol1:[Background,exVSThumbP] := 0x2000000
oDCOCX_Exontrol1:[Background,exVSThumbH] := 0x3000000
oDCOCX_Exontrol1:ColumnAutoResize := false
oDCOCX_Exontrol1:ScrollBySingleLine := true
IColumn{oDCOCX_Exontrol1:Columns:Add("S")}:Width := 483
var_Items := oDCOCX_Exontrol1:Items
	var_Items:[ItemHeight,var_Items:AddItem("Item 1")] := 248
oDCOCX_Exontrol1:Items:AddItem("Item 2")
236
How do I change the visual appearance for the item, using your EBN technology

local var_Items as IItems
local h,hC as USUAL

oDCOCX_Exontrol1:VisualAppearance:Add(1,"c:\exontrol\images\normal.ebn")
oDCOCX_Exontrol1:Columns:Add("Default")
var_Items := oDCOCX_Exontrol1:Items
	h := var_Items:AddItem("Root")
	hC := var_Items:InsertItem(h,nil,"Child 1")
	var_Items:[ItemBackColor,hC] := 0x1000000
	var_Items:InsertItem(h,nil,"Child 2")
	var_Items:[ExpandItem,h] := true
98
How do I change the visual appearance effect for the selected item, using EBN


oDCOCX_Exontrol1:VisualAppearance:Add(1,"c:\exontrol\images\normal.ebn")
oDCOCX_Exontrol1:SelBackColor := 0x1000000
oDCOCX_Exontrol1:SelForeColor := RGB(0,0,0)
oDCOCX_Exontrol1:ShowFocusRect := false
oDCOCX_Exontrol1:Columns:Add("Column")
oDCOCX_Exontrol1:Items:AddItem(0)
oDCOCX_Exontrol1:Items:AddItem(1)
335
How do I change the text in the edit or label area

local var_Items as IItems

oDCOCX_Exontrol1:Columns:Add("Column")
var_Items := oDCOCX_Exontrol1:Items
	var_Items:AddItem("Item 3")
	var_Items:AddItem("Item 1")
	var_Items:AddItem("Item 2")
oDCOCX_Exontrol1:[EditText,0] := "Test"
157
How do I change the item's foreground color for numbers between an interval - Range


oDCOCX_Exontrol1:ConditionalFormats:Add("%0 >= 2 and %0 <= 10",nil):ForeColor := RGB(255,0,0)
oDCOCX_Exontrol1:Columns:Add("Numbers")
oDCOCX_Exontrol1:Items:AddItem(1)
oDCOCX_Exontrol1:Items:AddItem(2)
oDCOCX_Exontrol1:Items:AddItem(10)
oDCOCX_Exontrol1:Items:AddItem(20)
156
How do I change the item's background color for numbers less than a value


oDCOCX_Exontrol1:ConditionalFormats:Add("%0 < 10",nil):BackColor := RGB(255,0,0)
oDCOCX_Exontrol1:Columns:Add("Numbers")
oDCOCX_Exontrol1:Items:AddItem(1)
oDCOCX_Exontrol1:Items:AddItem(2)
oDCOCX_Exontrol1:Items:AddItem(10)
oDCOCX_Exontrol1:Items:AddItem(20)
102
How do I change the height of the control's filterbar

local var_Column as IColumn

oDCOCX_Exontrol1:FilterBarHeight := 32
var_Column := IColumn{oDCOCX_Exontrol1:Columns:Add("Column")}
	var_Column:DisplayFilterButton := true
	var_Column:FilterType := exBlanks
oDCOCX_Exontrol1:ApplyFilter()
251
How do I change the height of an item

local var_Items as IItems

oDCOCX_Exontrol1:ScrollBySingleLine := true
oDCOCX_Exontrol1:Columns:Add("Default")
var_Items := oDCOCX_Exontrol1:Items
	var_Items:[ItemHeight,var_Items:AddItem("height")] := 128
oDCOCX_Exontrol1:Items:AddItem("enabled")
101
How do I change the header's foreground color


oDCOCX_Exontrol1:HeaderForeColor := RGB(255,0,0)
oDCOCX_Exontrol1:Columns:Add("Column 1")
oDCOCX_Exontrol1:Columns:Add("Column 2")
oDCOCX_Exontrol1:Items:AddItem("Item 1")
103
How do I change the foreground color of the control's filterbar

local var_Column as IColumn

oDCOCX_Exontrol1:FilterBarForeColor := RGB(255,0,0)
var_Column := IColumn{oDCOCX_Exontrol1:Columns:Add("Column")}
	var_Column:DisplayFilterButton := true
	var_Column:FilterType := exBlanks
oDCOCX_Exontrol1:ApplyFilter()
237
How do I change the foreground color for the item

local var_Items as IItems
local h,hC as USUAL

oDCOCX_Exontrol1:Columns:Add("Default")
var_Items := oDCOCX_Exontrol1:Items
	h := var_Items:AddItem("Root")
	hC := var_Items:InsertItem(h,nil,"Child 1")
	var_Items:[ItemForeColor,hC] := RGB(255,0,0)
	var_Items:InsertItem(h,nil,"Child 2")
	var_Items:[ExpandItem,h] := true
106
How do I change the font of the control's filterbar

local var_Column as IColumn

oDCOCX_Exontrol1:FilterBarFont:Size := 20
var_Column := IColumn{oDCOCX_Exontrol1:Columns:Add("Column")}
	var_Column:DisplayFilterButton := true
	var_Column:FilterType := exBlanks
oDCOCX_Exontrol1:ApplyFilter()
568
How do I change the drop down filter icon/button (black)

local var_Appearance as IAppearance
local var_Column as IColumn
local var_Items as IItems

oDCOCX_Exontrol1:BeginUpdate()
var_Appearance := oDCOCX_Exontrol1:VisualAppearance
	var_Appearance:Add(1,"gBFLBCJwBAEHhEJAAEhABXUIQAAYAQGKIcBiAKBQAGYBIJDEMgzDDAUBjKKocQTC4AIQjCK4JDKHYJRpHEZyCA8EhqGASRAFUQBYiWE4oSpLABQaK0ZwIGyRIrkGQgQgmPYDSDNU4zVIEEglBI0TDNczhNDENgtGYaJqHIYpZBcM40TKkEZoSIITZcRrOEBiRL1S0RBhGcRUHZlWzdN64LhuK47UrWdD/XhdVzXRbjfz1Oq+bxve48Br7A5yYThdr4LhOFQ3RjIL4xbIcUwGe6VZhjOLZXjmO49T69HTtOCYBEBA")
oDCOCX_Exontrol1:[Background,exCursorHoverColumn] := -1
oDCOCX_Exontrol1:[Background,exHeaderFilterBarButton] := 0x1000000
oDCOCX_Exontrol1:[Background,exBackColorFilter] := RGB(0,0,1)
oDCOCX_Exontrol1:[Background,exForeColorFilter] := RGB(255,255,255)
oDCOCX_Exontrol1:[Description,exFilterBarExclude] := "<bgcolor 0><fgcolor ffffff> Exclude </fgcolor></bgcolor>"
oDCOCX_Exontrol1:HeaderAppearance := None2
oDCOCX_Exontrol1:HeaderBackColor := RGB(0,0,0)
oDCOCX_Exontrol1:HeaderForeColor := RGB(255,255,255)
oDCOCX_Exontrol1:HeaderVisible := true
var_Column := IColumn{oDCOCX_Exontrol1:Columns:Add("Filter")}
	var_Column:FilterList := exShowExclude | exShowCheckBox
	var_Column:DisplayFilterButton := true
	var_Column:AllowSort := false
	var_Column:AllowDragging := false
var_Items := oDCOCX_Exontrol1:Items
	var_Items:AddItem("One")
	var_Items:AddItem("Two")
	var_Items:AddItem("Three")
oDCOCX_Exontrol1:EndUpdate()
86
How do I change the control's foreground color


oDCOCX_Exontrol1:ForeColor := RGB(120,120,120)
oDCOCX_Exontrol1:Columns:Add("Column")
oDCOCX_Exontrol1:Items:AddItem("item")
322
How do I change the control's border, using your EBN files


oDCOCX_Exontrol1:VisualAppearance:Add(1,"c:\exontrol\images\normal.ebn")
oDCOCX_Exontrol1:Appearance := 0x1000000 |
85
How do I change the control's background color


oDCOCX_Exontrol1:BackColor := RGB(200,200,200)
87
How do I change the control's background / foreground color on the locked area

local var_Items as IItems

oDCOCX_Exontrol1:CountLockedColumns := 1
oDCOCX_Exontrol1:ForeColorLock := RGB(240,240,240)
oDCOCX_Exontrol1:BackColorLock := RGB(128,128,128)
oDCOCX_Exontrol1:ColumnAutoResize := false
IColumn{oDCOCX_Exontrol1:Columns:Add("Locked")}:Width := 128
IColumn{oDCOCX_Exontrol1:Columns:Add("Un-Locked 1")}:Width := 128
IColumn{oDCOCX_Exontrol1:Columns:Add("Un-Locked 2")}:Width := 128
IColumn{oDCOCX_Exontrol1:Columns:Add("Un-Locked 3")}:Width := 128
var_Items := oDCOCX_Exontrol1:Items
	var_Items:[CellCaption,var_Items:AddItem("locked"),1] := "unlocked"
158
How do I change the column's foreground color for numbers between an interval - Range

local var_ConditionalFormat as IConditionalFormat
local var_Items,var_Items1,var_Items2,var_Items3 as IItems

var_ConditionalFormat := oDCOCX_Exontrol1:ConditionalFormats:Add("%0 >= 2 and %0 <= 10",nil)
	var_ConditionalFormat:Bold := true
	var_ConditionalFormat:ForeColor := RGB(255,0,0)
	var_ConditionalFormat:ApplyTo := 0x1 | 
oDCOCX_Exontrol1:Columns:Add("N1")
oDCOCX_Exontrol1:Columns:Add("N2")
var_Items := oDCOCX_Exontrol1:Items
	var_Items:[CellCaption,var_Items:AddItem(1),1] := 2
var_Items1 := oDCOCX_Exontrol1:Items
	var_Items1:[CellCaption,var_Items1:AddItem(3),1] := 3
var_Items2 := oDCOCX_Exontrol1:Items
	var_Items2:[CellCaption,var_Items2:AddItem(10),1] := 11
var_Items3 := oDCOCX_Exontrol1:Items
	var_Items3:[CellCaption,var_Items3:AddItem(13),1] := 31
oDCOCX_Exontrol1:SearchColumnIndex := 1
175
How do I change the column's caption


IColumn{oDCOCX_Exontrol1:Columns:Add("Column")}:Caption := "new caption"
97
How do I change the colors for the selected item


oDCOCX_Exontrol1:SelBackColor := RGB(0,0,0)
oDCOCX_Exontrol1:Columns:Add("Column")
oDCOCX_Exontrol1:Items:AddItem(0)
oDCOCX_Exontrol1:Items:AddItem(1)
267
How do I change the cell's foreground color

local var_Items as IItems
local h as USUAL

oDCOCX_Exontrol1:Columns:Add("C1")
oDCOCX_Exontrol1:Columns:Add("C2")
var_Items := oDCOCX_Exontrol1:Items
	h := var_Items:AddItem("Cell 1")
	var_Items:[CellCaption,h,1] := "Cell 2"
	var_Items:[CellForeColor,h,1] := RGB(255,0,0)
265
How do I change the cell's background color

local var_Items as IItems
local h as USUAL

oDCOCX_Exontrol1:Columns:Add("C1")
oDCOCX_Exontrol1:Columns:Add("C2")
var_Items := oDCOCX_Exontrol1:Items
	h := var_Items:AddItem("Cell 1")
	var_Items:[CellCaption,h,1] := "Cell 2"
	var_Items:[CellBackColor,h,1] := RGB(255,0,0)
264
How do I change the caption or value for a particular cell

local var_Items as IItems

oDCOCX_Exontrol1:Columns:Add("C1")
oDCOCX_Exontrol1:Columns:Add("C2")
var_Items := oDCOCX_Exontrol1:Items
	var_Items:[CellCaption,var_Items:AddItem("Cell 1"),1] := "Cell 2"
115
How do I change the caption being displayed in the control's filter bar

local var_Column as IColumn

oDCOCX_Exontrol1:FilterBarCaption := "your filter caption"
var_Column := IColumn{oDCOCX_Exontrol1:Columns:Add("Column")}
	var_Column:DisplayFilterButton := true
	var_Column:FilterType := exBlanks
oDCOCX_Exontrol1:ApplyFilter()
104
How do I change the background color of the control's filterbar

local var_Column as IColumn

oDCOCX_Exontrol1:FilterBarBackColor := RGB(240,240,240)
var_Column := IColumn{oDCOCX_Exontrol1:Columns:Add("Column")}
	var_Column:DisplayFilterButton := true
	var_Column:FilterType := exBlanks
oDCOCX_Exontrol1:ApplyFilter()
235
How do I change the background color for the item

local var_Items as IItems
local h,hC as USUAL

oDCOCX_Exontrol1:Columns:Add("Default")
var_Items := oDCOCX_Exontrol1:Items
	h := var_Items:AddItem("Root")
	hC := var_Items:InsertItem(h,nil,"Child 1")
	var_Items:[ItemBackColor,hC] := RGB(255,0,0)
	var_Items:InsertItem(h,nil,"Child 2")
	var_Items:[ExpandItem,h] := true
33
How do I change the "All", "Blanks" or/and "NonBlanks" caption in the drop down filter window


IColumn{oDCOCX_Exontrol1:Columns:Add("Column")}:DisplayFilterButton := true
oDCOCX_Exontrol1:[Description,exFilterBarAll] := "new name for (All)"
111
How do I call your x-script language

local var_Column as IColumn

var_Column := IColumn{oDCOCX_Exontrol1:ExecuteTemplate("Columns.Add(`Column`)")}
	var_Column:HeaderStrikeOut := true
	var_Column:HeaderBold := true
110
How do I call your x-script language


oDCOCX_Exontrol1:Template := "Columns.Add(`Column`).HTMLCaption = `<b>C</b>olumn`"
238
How do I bold an item

local var_Items as IItems

oDCOCX_Exontrol1:Columns:Add("Default")
var_Items := oDCOCX_Exontrol1:Items
	var_Items:[ItemBold,var_Items:AddItem("bold")] := true
239
How do I bold a cell or an item

local var_Items as IItems

oDCOCX_Exontrol1:Columns:Add("Default")
var_Items := oDCOCX_Exontrol1:Items
	var_Items:[CellCaptionFormat,var_Items:AddItem("gets <b>bold</b> only a portion of text"),0] := exHTML
240
How do I bold a cell

local var_Items as IItems

oDCOCX_Exontrol1:Columns:Add("Default")
var_Items := oDCOCX_Exontrol1:Items
	var_Items:[CellBold,var_Items:AddItem("bold"),0] := true
233
How do I associate an extra data to an item

local var_Items as IItems

oDCOCX_Exontrol1:Columns:Add("Default")
var_Items := oDCOCX_Exontrol1:Items
	var_Items:[ItemData,var_Items:AddItem("item")] := "your extra data"
163
How do I assign an icon to the button in the scrollbar


oDCOCX_Exontrol1:Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yNAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=")
oDCOCX_Exontrol1:[ScrollPartVisible,exHScroll,exLeftB1Part] := true
oDCOCX_Exontrol1:[ScrollPartCaption,exHScroll,exLeftB1Part] := "<img>1</img>"
oDCOCX_Exontrol1:ScrollHeight := 18
oDCOCX_Exontrol1:ScrollButtonWidth := 18
164
How do I assign a tooltip to a scrollbar


oDCOCX_Exontrol1:[ScrollToolTip,exHScroll] := "This is a tooltip being shown when you click and drag the thumb in the horizontal scroll bar"
oDCOCX_Exontrol1:ColumnAutoResize := false
IColumn{oDCOCX_Exontrol1:Columns:Add("C1")}:Width := 256
IColumn{oDCOCX_Exontrol1:Columns:Add("C2")}:Width := 256
IColumn{oDCOCX_Exontrol1:Columns:Add("C3")}:Width := 256
578
How do I assign a database to your control, using ADO, ADOR or ADODB objects (MDB,JET)

local rs as _Recordset

oDCOCX_Exontrol1:BeginUpdate()
oDCOCX_Exontrol1:ColumnAutoResize := false
// Generate Source for 'Microsoft ActiveX Data Objects 6.1 Library(msado15.dll)' server from Tools\Automation Server...
rs := _Recordset{"ADOR.Recordset"}
	rs:Open("Orders","Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\Exontrol\ExComboBox\Sample\Access\SAMPLE.MDB",3,3,0)
oDCOCX_Exontrol1:DataSource := _Recordset{rs}
oDCOCX_Exontrol1:EndUpdate()
99
How do I assign a database to your control, using ADO, ADOR or ADODB objects

local rs as _Recordset

oDCOCX_Exontrol1:ColumnAutoResize := false
// Generate Source for 'Microsoft ActiveX Data Objects 6.1 Library(msado15.dll)' server from Tools\Automation Server...
rs := _Recordset{"ADOR.Recordset"}
	rs:Open("Orders","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExComboBox\Sample\Access\SAMPLE.MDB",3,3,0)
oDCOCX_Exontrol1:DataSource := _Recordset{rs}
200
How do I arrange my columns on multiple lines


oDCOCX_Exontrol1:HeaderHeight := 32
IColumn{oDCOCX_Exontrol1:Columns:Add("")}:HTMLCaption := "Line 1<br>Line 2"
201
How do I arrange my columns on multiple levels


IColumn{oDCOCX_Exontrol1:Columns:Add("S")}:Width := 32
IColumn{oDCOCX_Exontrol1:Columns:Add("Level 2")}:LevelKey := 1
IColumn{oDCOCX_Exontrol1:Columns:Add("Level 3")}:LevelKey := 1
IColumn{oDCOCX_Exontrol1:Columns:Add("Level 4")}:LevelKey := 1
IColumn{oDCOCX_Exontrol1:Columns:Add("Level 1")}:LevelKey := "2"
IColumn{oDCOCX_Exontrol1:Columns:Add("Level 2")}:LevelKey := "2"
IColumn{oDCOCX_Exontrol1:Columns:Add("Level 3")}:LevelKey := "2"
IColumn{oDCOCX_Exontrol1:Columns:Add("Level 4")}:LevelKey := "2"
IColumn{oDCOCX_Exontrol1:Columns:Add("E")}:Width := 32
303
How do I apply HTML format to a cell

local var_Items as IItems
local h as USUAL

oDCOCX_Exontrol1:TreeColumnIndex := -1
oDCOCX_Exontrol1:Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yNAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=")
oDCOCX_Exontrol1:[HTMLPicture,"p1"] := "c:\exontrol\images\zipdisk.gif"
oDCOCX_Exontrol1:[HTMLPicture,"p2"] := "c:\exontrol\images\auction.gif"
oDCOCX_Exontrol1:Columns:Add("Default")
var_Items := oDCOCX_Exontrol1:Items
	h := var_Items:AddItem("The following item shows some of the HTML format supported:")
	var_Items:[CellHAlignment,h,0] := CenterAlignment
	h := var_Items:AddItem("<br>text icons <img>1</img>, <img>2</img>, ... pictures <img>p1</img>, <img>p2</img> <br><br>text <b>bold</b>, <i>italic</i>, <u>underline</u>, <s>strikeout</s>, ...<br><dotline>and so on...<br> <a>anchor</a> or <a2>hyperlink</a><br><fgcolor=FF0000>fgcolor</fgcolor> or <bgcolor=00FF00>bgcolor</bgcolor> ")
	var_Items:[CellCaptionFormat,h,0] := exHTML
	var_Items:[CellSingleLine,h,0] := exCaptionWordWrap
182
How do I align the icon in the column's header to the right

local var_Column as IColumn

oDCOCX_Exontrol1:Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yNAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=")
var_Column := IColumn{oDCOCX_Exontrol1:Columns:Add("ColumnName")}
	var_Column:HeaderImage := 1
	var_Column:HeaderImageAlignment := RightAlignment
346
How do change the visual appearance for the drop down border, using EBN


oDCOCX_Exontrol1:VisualAppearance:Add(1,"c:\exontrol\images\normal.ebn")
oDCOCX_Exontrol1:DropDownBorder := 0x1000000 |
70
How do change the visual appearance for the control's header bar, using EBN


oDCOCX_Exontrol1:VisualAppearance:Add(1,"c:\exontrol\images\normal.ebn")
oDCOCX_Exontrol1:HeaderBackColor := 0x1000000
197
How do change the vertical alignment for all cells in the column

local var_Items,var_Items1 as IItems

IColumn{oDCOCX_Exontrol1:Columns:Add("MultipleLine")}:[Def,exCellSingleLine] := false
IColumn{oDCOCX_Exontrol1:Columns:Add("VAlign")}:[Def,exCellVAlignment] := 2
var_Items := oDCOCX_Exontrol1:Items
	var_Items:[CellCaption,var_Items:AddItem("This is a bit of long text that should break the line"),1] := "bottom"
var_Items1 := oDCOCX_Exontrol1:Items
	var_Items1:[CellCaption,var_Items1:AddItem("This is a bit of long text that should break the line"),1] := "bottom"
196
How do change the foreground color for all cells in the column


IColumn{oDCOCX_Exontrol1:Columns:Add("ForeColor")}:[Def,exCellForeColor] := 255
oDCOCX_Exontrol1:Items:AddItem(0)
oDCOCX_Exontrol1:Items:AddItem(1)
195
How do change the background color for all cells in the column


IColumn{oDCOCX_Exontrol1:Columns:Add("BackColor")}:[Def,exCellBackColor] := 255
oDCOCX_Exontrol1:Items:AddItem(0)
oDCOCX_Exontrol1:Items:AddItem(1)
5
How can I use HTML format in column's header


IColumn{oDCOCX_Exontrol1:Columns:Add("ColumnName")}:HTMLCaption := "<b>HTML</b> <fgcolor=0000FF>Col</fgcolor>umn"
28
How can I underline the column's header


IColumn{oDCOCX_Exontrol1:Columns:Add("Column 1")}:HeaderUnderline := true
213
How can I underline all cells in the column

local var_ConditionalFormat as IConditionalFormat

var_ConditionalFormat := oDCOCX_Exontrol1:ConditionalFormats:Add("1",nil)
	var_ConditionalFormat:Underline := true
	var_ConditionalFormat:ApplyTo := exFormatToColumns
oDCOCX_Exontrol1:Columns:Add("Column")
oDCOCX_Exontrol1:Items:AddItem(0)
oDCOCX_Exontrol1:Items:AddItem(1)
185
How can I specify the minimum width for the column, if I use WidthAutoResize property

local var_Column as IColumn

var_Column := IColumn{oDCOCX_Exontrol1:Columns:Add("Auto")}
	var_Column:WidthAutoResize := true
	var_Column:MinWidthAutoResize := 32
oDCOCX_Exontrol1:Items:AddItem(0)
oDCOCX_Exontrol1:Items:AddItem(1)
186
How can I specify the maximum width for the column, if I use WidthAutoResize property

local var_Column as IColumn

var_Column := IColumn{oDCOCX_Exontrol1:Columns:Add("Auto")}
	var_Column:WidthAutoResize := true
	var_Column:MinWidthAutoResize := 32
	var_Column:MaxWidthAutoResize := 128
oDCOCX_Exontrol1:Items:AddItem(0)
oDCOCX_Exontrol1:Items:AddItem(1)
441
How can I specify the format for negative numbers

local var_Items as IItems
local h as USUAL

oDCOCX_Exontrol1:BeginUpdate()
IColumn{oDCOCX_Exontrol1:Columns:Add("Def")}:[Def,exCellCaptionFormat] := 1
var_Items := oDCOCX_Exontrol1:Items
	h := var_Items:AddItem(-100000.27)
	var_Items:[FormatCell,h,0] := "(value format '') +  ' <fgcolor=808080>(default)'"
	h := var_Items:AddItem(-100000.27)
	var_Items:[FormatCell,h,0] := "(value format '||||1') +  ' <fgcolor=808080>(Negative sign, number; for example, -1.1)'"
oDCOCX_Exontrol1:EndUpdate()
432
How can I specify an item to be always the last item

local var_Items as IItems
local h as USUAL

oDCOCX_Exontrol1:BeginUpdate()
oDCOCX_Exontrol1:TreeColumnIndex := -1
IColumn{oDCOCX_Exontrol1:Columns:Add("Numbers")}:SortType := SortNumeric
var_Items := oDCOCX_Exontrol1:Items
	var_Items:AddItem(1)
	var_Items:AddItem(2)
	var_Items:AddItem(3)
	var_Items:AddItem(4)
	h := var_Items:AddItem("last")
	var_Items:[CellHAlignment,h,0] := RightAlignment
	var_Items:[SortableItem,h] := false
	var_Items:SortChildren(0,0,true)
oDCOCX_Exontrol1:EndUpdate()
433
How can I specify an item to be always the first item

local var_Items as IItems
local h as USUAL

oDCOCX_Exontrol1:BeginUpdate()
oDCOCX_Exontrol1:TreeColumnIndex := -1
IColumn{oDCOCX_Exontrol1:Columns:Add("Numbers")}:SortType := SortNumeric
var_Items := oDCOCX_Exontrol1:Items
	var_Items:AddItem(1)
	var_Items:AddItem(2)
	var_Items:AddItem(3)
	var_Items:AddItem(4)
	h := var_Items:AddItem("first")
	var_Items:[ItemPosition,h] := 0
	var_Items:[CellHAlignment,h,0] := RightAlignment
	var_Items:[SortableItem,h] := false
	var_Items:SortChildren(0,0,false)
oDCOCX_Exontrol1:EndUpdate()
530
How can I specify alternate background colors for each root item, similar with BackColorAlternate

local var_Column,var_Column1 as IColumn
local var_ConditionalFormat as IConditionalFormat
local var_Items as IItems
local h as USUAL

oDCOCX_Exontrol1:BeginUpdate()
oDCOCX_Exontrol1:LinesAtRoot := exLinesAtRoot
var_Column := IColumn{oDCOCX_Exontrol1:Columns:Add("Default")}
	var_Column:[Def,exCellHasCheckBox] := true
	var_Column:PartialCheck := true
var_Column1 := IColumn{oDCOCX_Exontrol1:Columns:Add("Position")}
	var_Column1:FormatColumn := "( ( 1:=( ( 0:=(1 rpos '') ) lfind `.`) ) < 0 ? =:0 : (=:0 left =:1) )"
	var_Column1:Visible := false
var_ConditionalFormat := oDCOCX_Exontrol1:ConditionalFormats:Add("%C1 mod 2",nil)
	var_ConditionalFormat:BackColor := RGB(240,240,240)
var_Items := oDCOCX_Exontrol1:Items
	h := var_Items:AddItem("Root 1")
	var_Items:InsertItem(h,nil,"Child 1")
	var_Items:InsertItem(h,nil,"Child 2")
	var_Items:[ExpandItem,h] := true
	h := var_Items:AddItem("Root 2")
	var_Items:InsertItem(h,nil,"Child 1")
	var_Items:InsertItem(h,nil,"Child 2")
	h := var_Items:AddItem("Root 3")
	var_Items:InsertItem(h,nil,"Child 1")
	var_Items:InsertItem(h,nil,"Child 2")
oDCOCX_Exontrol1:EndUpdate()
355
How can I sort the value gets listed in the drop down filter window

local var_Column,var_Column1 as IColumn
local var_Items as IItems
local h as USUAL

oDCOCX_Exontrol1:LinesAtRoot := exLinesAtRoot
oDCOCX_Exontrol1:MarkSearchColumn := false
oDCOCX_Exontrol1:[Description,exFilterBarAll] := ""
oDCOCX_Exontrol1:[Description,exFilterBarBlanks] := ""
oDCOCX_Exontrol1:[Description,exFilterBarNonBlanks] := ""
var_Column := IColumn{oDCOCX_Exontrol1:Columns:Add("P1")}
	var_Column:DisplayFilterButton := true
	var_Column:DisplayFilterPattern := false
	var_Column:FilterList := exSortItemsDesc
var_Column1 := IColumn{oDCOCX_Exontrol1:Columns:Add("P2")}
	var_Column1:DisplayFilterButton := true
	var_Column1:DisplayFilterPattern := false
	var_Column1:FilterList := exSortItemsAsc
var_Items := oDCOCX_Exontrol1:Items
	h := var_Items:AddItem("Z3")
	var_Items:[CellCaption,h,1] := "C"
	var_Items:[CellCaption,var_Items:InsertItem(h,nil,"Z1"),1] := "B"
	var_Items:[CellCaption,var_Items:InsertItem(h,nil,"Z2"),1] := "A"
	var_Items:[ExpandItem,h] := true
230
How can I sort the items

local var_Items as IItems
local h as USUAL

oDCOCX_Exontrol1:Columns:Add("Default")
var_Items := oDCOCX_Exontrol1:Items
	h := var_Items:AddItem("Root")
	var_Items:InsertItem(h,nil,"Child 1")
	var_Items:InsertItem(h,nil,"Child 2")
	var_Items:[ExpandItem,h] := true
oDCOCX_Exontrol1:Columns:[Item,"Default"]:SortOrder := SortDescending
136
How can I sort by multiple columns


oDCOCX_Exontrol1:SingleSort := false
IColumn{oDCOCX_Exontrol1:Columns:Add("C1")}:SortOrder := SortAscending
IColumn{oDCOCX_Exontrol1:Columns:Add("C2")}:SortOrder := SortDescending
IColumn{oDCOCX_Exontrol1:Columns:Add("C3")}:SortOrder := SortAscending
434
How can I simulate displaying groups

local var_Columns as IColumns
local var_Items as IItems
local h,h1 as USUAL

oDCOCX_Exontrol1:HasLines := exNoLine
oDCOCX_Exontrol1:ScrollBySingleLine := true
var_Columns := oDCOCX_Exontrol1:Columns
	var_Columns:Add("Name")
	var_Columns:Add("A")
	var_Columns:Add("B")
	var_Columns:Add("C")
var_Items := oDCOCX_Exontrol1:Items
	h := var_Items:AddItem("Group 1")
	var_Items:[CellHAlignment,h,0] := CenterAlignment
	var_Items:[ItemDivider,h] := 0
	var_Items:[ItemDividerLineAlignment,h] := DividerBoth
	var_Items:[ItemHeight,h] := 24
	var_Items:[SortableItem,h] := false
	h1 := var_Items:InsertItem(h,nil,"Child 1")
	var_Items:[CellCaption,h1,1] := 1
	var_Items:[CellCaption,h1,2] := 2
	var_Items:[CellCaption,h1,3] := 3
	h1 := var_Items:InsertItem(h,nil,"Child 2")
	var_Items:[CellCaption,h1,1] := 4
	var_Items:[CellCaption,h1,2] := 5
	var_Items:[CellCaption,h1,3] := 6
	var_Items:[ExpandItem,h] := true
	h := var_Items:AddItem("Group 2")
	var_Items:[CellHAlignment,h,0] := CenterAlignment
	var_Items:[ItemDivider,h] := 0
	var_Items:[ItemDividerLineAlignment,h] := DividerBoth
	var_Items:[ItemHeight,h] := 24
	var_Items:[SortableItem,h] := false
	h1 := var_Items:InsertItem(h,nil,"Child 1")
	var_Items:[CellCaption,h1,1] := 1
	var_Items:[CellCaption,h1,2] := 2
	var_Items:[CellCaption,h1,3] := 3
	h1 := var_Items:InsertItem(h,nil,"Child 2")
	var_Items:[CellCaption,h1,1] := 4
	var_Items:[CellCaption,h1,2] := 5
	var_Items:[CellCaption,h1,3] := 6
	var_Items:[ExpandItem,h] := true
128
How can I show the locked / fixed items on the bottom side of the control

local var_Items as IItems

oDCOCX_Exontrol1:ShowLockedItems := true
oDCOCX_Exontrol1:Columns:Add("Column")
var_Items := oDCOCX_Exontrol1:Items
	var_Items:[LockedItemCount,exMiddle] := 2
	var_Items:[CellCaption,var_Items:[LockedItem,exMiddle,0],0] := "locked item 1"
	var_Items:[CellCaption,var_Items:[LockedItem,exMiddle,1],0] := "locked item 2"
	var_Items:AddItem("un-locked item")
127
How can I show the locked / fixed items

local var_Items as IItems

oDCOCX_Exontrol1:ShowLockedItems := true
oDCOCX_Exontrol1:Columns:Add("Column")
var_Items := oDCOCX_Exontrol1:Items
	var_Items:[LockedItemCount,exTop] := 2
	var_Items:[CellCaption,var_Items:[LockedItem,exTop,0],0] := "locked item 1"
	var_Items:[CellCaption,var_Items:[LockedItem,exTop,1],0] := "locked item 2"
	var_Items:AddItem("un-locked item")
336
How can I show the drop down window as soon as user starts typing in the control

local var_Items as IItems

oDCOCX_Exontrol1:AutoDropDown := true
oDCOCX_Exontrol1:Columns:Add("Column")
var_Items := oDCOCX_Exontrol1:Items
	var_Items:AddItem("Item 3")
	var_Items:AddItem("Item 1")
	var_Items:AddItem("Item 2")
125
How can I show the control's sort bar


oDCOCX_Exontrol1:SortBarVisible := true
55
How can I show the control's grid lines only for added/visible items


oDCOCX_Exontrol1:MarkSearchColumn := false
oDCOCX_Exontrol1:DrawGridLines := exRowLines
oDCOCX_Exontrol1:Columns:Add("Column 1")
oDCOCX_Exontrol1:Columns:Add("Column 2")
oDCOCX_Exontrol1:Items:AddItem(0)
oDCOCX_Exontrol1:Items:AddItem(1)
oDCOCX_Exontrol1:Items:AddItem(2)
17
How can I show the control's grid lines


oDCOCX_Exontrol1:MarkSearchColumn := false
oDCOCX_Exontrol1:DrawGridLines := exAllLines
oDCOCX_Exontrol1:Columns:Add("Column 1")
oDCOCX_Exontrol1:Columns:Add("Column 2")
oDCOCX_Exontrol1:Items:AddItem(0)
oDCOCX_Exontrol1:Items:AddItem(1)
oDCOCX_Exontrol1:Items:AddItem(2)
449
How can I show the child items with no identation

local var_Items as IItems
local h as USUAL

oDCOCX_Exontrol1:LinesAtRoot := exGroupLinesOutside
oDCOCX_Exontrol1:Indent := 12
oDCOCX_Exontrol1:HasLines := exThinLine
oDCOCX_Exontrol1:Columns:Add("Default")
var_Items := oDCOCX_Exontrol1:Items
	h := var_Items:AddItem("Root 1")
	var_Items:InsertItem(h,nil,"Child 1")
	var_Items:InsertItem(h,nil,"Child 2")
	var_Items:InsertItem(h,nil,"Child 3")
	var_Items:[ExpandItem,h] := true
	h := var_Items:AddItem("Root 2")
	var_Items:InsertItem(h,nil,"Child 1")
	var_Items:InsertItem(h,nil,"Child 2")
	var_Items:InsertItem(h,nil,"Child 3")
12
How can I show or hide a column


IColumn{oDCOCX_Exontrol1:Columns:Add("Hidden")}:Visible := false
204
How can I show or display the control's filter


IColumn{oDCOCX_Exontrol1:Columns:Add("Filter")}:DisplayFilterButton := true
480
How can I show only the matching items, while user types in the drop down control

METHOD OCX_Exontrol1EditChange(ColIndex) CLASS MainDialog
	// EditChange event - Fired when the user has taken an action that may have altered text in an edit control.
	local var_Items as IItems
	local sLabel as USUAL
	sLabel := oDCOCX_Exontrol1:[EditText,ColIndex]
	OutputDebugString(String2Psz( "Select the item that maches exactly the typing label: " ))
	OutputDebugString(String2Psz( AsString(sLabel) ))
	var_Items := oDCOCX_Exontrol1:Items
		var_Items:[SelectItem,var_Items:FocusItem] := false
		var_Items:[SelectItem,var_Items:[FindItem,sLabel,ColIndex,nil]] := true
RETURN NIL

local var_Items as IItems

oDCOCX_Exontrol1:BeginUpdate()
oDCOCX_Exontrol1:SingleEdit := true
oDCOCX_Exontrol1:AutoComplete := false
oDCOCX_Exontrol1:AutoSelect := false
oDCOCX_Exontrol1:AutoSearch := false
oDCOCX_Exontrol1:AutoDropDown := true
oDCOCX_Exontrol1:IntegralHeight := true
oDCOCX_Exontrol1:HeaderVisible := false
oDCOCX_Exontrol1:Columns:Add("Friends")
var_Items := oDCOCX_Exontrol1:Items
	var_Items:AddItem("Fred")
	var_Items:AddItem("Tina")
	var_Items:AddItem("Tom")
oDCOCX_Exontrol1:EndUpdate()
212
How can I show in italic all data in the column

local var_ConditionalFormat as IConditionalFormat

var_ConditionalFormat := oDCOCX_Exontrol1:ConditionalFormats:Add("1",nil)
	var_ConditionalFormat:Italic := true
	var_ConditionalFormat:ApplyTo := exFormatToColumns
oDCOCX_Exontrol1:Columns:Add("Column")
oDCOCX_Exontrol1:Items:AddItem(0)
oDCOCX_Exontrol1:Items:AddItem(1)
214
How can I show as strikeout all cells in the column

local var_ConditionalFormat as IConditionalFormat

var_ConditionalFormat := oDCOCX_Exontrol1:ConditionalFormats:Add("1",nil)
	var_ConditionalFormat:StrikeOut := true
	var_ConditionalFormat:ApplyTo := exFormatToColumns
oDCOCX_Exontrol1:Columns:Add("Column")
oDCOCX_Exontrol1:Items:AddItem(0)
oDCOCX_Exontrol1:Items:AddItem(1)
208
How can I show a column that adds values in the cells

local var_Items,var_Items1 as IItems

oDCOCX_Exontrol1:Columns:Add("A")
oDCOCX_Exontrol1:Columns:Add("B")
IColumn{oDCOCX_Exontrol1:Columns:Add("A+B")}:ComputedField := "%0 + %1"
var_Items := oDCOCX_Exontrol1:Items
	var_Items:[CellCaption,var_Items:AddItem(1),1] := 2
var_Items1 := oDCOCX_Exontrol1:Items
	var_Items1:[CellCaption,var_Items1:AddItem(10),1] := 20
600
How can I replace or add an icon at runtime


oDCOCX_Exontrol1:BeginUpdate()
oDCOCX_Exontrol1:ReplaceIcon("gAAAABgYACEHgUJFEEAAWhUJCEJEEJggEhMCYEXjUbjkJQECj8gj8hAEjkshYEpk8kf8ClsulsvAExmcvf83js5nU7nkCeEcn8boMaocXosCB9Hn09pkzcEuoL/fE+OkYB0gB9YhIHrddgVcr9aktZADAD8+P8CgIA==",nil)
oDCOCX_Exontrol1:ReplaceIcon("C:\images\favicon.ico",0)
IColumn{oDCOCX_Exontrol1:Columns:Add("Items")}:[Def,exCellCaptionFormat] := 1
oDCOCX_Exontrol1:Items:AddItem("Item <img>1</img>")
oDCOCX_Exontrol1:EndUpdate()
350
How can I remove the filter

local var_Column as IColumn

var_Column := IColumn{oDCOCX_Exontrol1:Columns:Add("Column")}
	var_Column:DisplayFilterButton := true
	var_Column:FilterType := exBlanks
oDCOCX_Exontrol1:ApplyFilter()
oDCOCX_Exontrol1:ClearFilter()
227
How can I remove or delete an item

local h as USUAL

oDCOCX_Exontrol1:Columns:Add("Default")
h := oDCOCX_Exontrol1:Items:AddItem("removed item")
oDCOCX_Exontrol1:Items:RemoveItem(h)
228
How can I remove or delete all items


oDCOCX_Exontrol1:Columns:Add("Default")
oDCOCX_Exontrol1:Items:AddItem("removed item")
oDCOCX_Exontrol1:Items:RemoveAllItems()